Accounts Receivable Aging Report

Aging Periods are the time span that the A/R account has a balance as of the "aged to" date selected. These arise when your property provides services and allows the customer to pay a specified amount of time later rather than at the time of service. Aging is the process of distinguishing open A/R accounts based on the length of time an invoice has been outstanding. The Accounts Receivable Aging Report categorizes the outstanding A/R accounts according to the length of time an invoice has been outstanding, showing each A/R Account that has a balance ("outstanding accounts"), and indicates whether the amount is current, 31-60 days old, 61-90 days old, or over 90 days old, and the total amount due. This report option can be utilized if desired to group MULTIPLE Property information together in a single report, as well as individual Properties in separate reports. An A/R aging report contains a list of your customers' unpaid invoices since the time the sales invoice was issued along with their duration.

Note: These aging periods are the default options but may be set otherwise using the Accounts Receivable Configuration screen, aging periods section.

The Accounts Receivable Aging Report command is found in the Accounting Menu, which may be reached using the File Menu.

 

 

 

Quick MenuFiles Menu

 

 

click Files => from the Other section of the Full Menu.

 

 

Click the icon on the left, or the breadcrumb words "Full Menu" on the top right of the screen to open the Full menu.

Full Menu Icon

This will display the Full menu in a tabular form, with four sections, Registration, Status, Cashier and Other.

Full Menu Table

Select Files => from the Other section.

Other section of Full Menu with Files => command selected

The Files Menu is divided into two sections, Files List 1 and Files List 2.

Files Menu screen

Select the Accounting => command from the Files List 2 section.

Files List 2 section of the Files Menu with Accounting => command selected

 

The Accounting Menu is divided into two sections, General and Reports.

Accounting Menu screen

Select the Accounts Receivable Aging Report command from the Reports section:

Reports section of the Accounting Menu with Accounts Receivable Aging Report command selected

 

When selected, the Accounts Receivable Aging Report screen will open.

Accounts Receivable Aging Report screen

 

Show All Hotels: This box may be checked or unchecked. By default it is unchecked, meaning the generated report will show information ONLY for the current Property. For this report, you may choose to show the information from ALL your Properties within Skyware on one report, rather than generating separate reports for each Property.

 

Select the Date Range for the report.

Aged To: The date selected is the "As Of" date for the age of outstanding accounts in the system. Use the drop-down menus or the calendar icon to select the Date you wish to have displayed on the report. By default the Date selected is today's Date.

 

Select the Report Options for the report. Choose ONE option using the radial buttons.

You can generate a Summary by Account, Summary by Invoice, or list the report by Transaction.

 

When finished, click the orange button Print Report.

Accounts Receivable Aging Report Summary by Accounts example

Once generated, the Accounts Receivable Aging Report shows each A/R Account that has a balance as of the "aged to" date selected. It indicates whether the amount is current, 31-60 days old, 61-90 days old, over 90 days old, and the total amount due.

Note: Again, these aging periods are the default options. If these aging period options are not those desired they may be set otherwise using the Accounts Receivable Configuration screen, aging periods section.

By default, the report is generated in PDF form and opens in a separate browser window. From there you can select to save or print the report, among other options. You can, instead, check the Generate report to excel checkbox to generate the report in HTML for downloading to Excel instead of PDF. The information in this case will then be correct for importing into another document rather than immediate viewing.

NOTE: The generated report appears as a pop-up window through your browser. If your browser is set to block pop-ups, you may receive a warning banner at the top of the browser. Click this banner and select to allow pop-ups so that you can view the report.

 

Date Updated August 12, 2021